/*
 * @(#)NoticeDAO.java $version 2013-3-1
 * 
 * Copyright 2013 NADO Group. All rights Reserved.
 * NADO PROPRIETARY/CONFIDENTIAL. Use is subject to license terms.
 */
package com.nado.iims2.community.dao;

import java.sql.SQLException;
import java.util.List;

import com.nado.extensions.util.DataMap;
import com.nado.iims2.community.model.NoticeModel;

/**
 * The Class NoticeDAO.
 * 
 * @author nado
 */
public interface NoticeDAO {
	/**
	 * Select notice list.
	 * 
	 * @param typeCd
	 * @param offset
	 * @param count
	 * @return
	 * @throws SQLException
	 */
	List<DataMap> selectNoticeList(String startDate, String endDate, String typeCd, int offset, int count) throws SQLException;
	/**
	 * Select notice list total.
	 * 
	 * @param typeCd
	 * @return
	 * @throws SQLException
	 */
	int selectNoticeListCount(String startDate, String endDate, String typeCd) throws SQLException;
	/**
	 * Select notice detail.
	 * 
	 * @param noticeNo
	 * @return
	 * @throws SQLException
	 */
	NoticeModel selectNoticeDetail(int noticeNo) throws SQLException;
	/**
	 * Insert notice info.
	 * 
	 * @param model
	 * @return
	 * @throws SQLException
	 */
	int insertNotice(NoticeModel model) throws SQLException;
	/**
	 * Update notice info.
	 * 
	 * @param model
	 * @return
	 * @throws SQLException
	 */
	int updateNotice(NoticeModel model) throws SQLException;
	/**
	 * Delete notice info.
	 * 
	 * @param model
	 * @return
	 * @throws SQLException
	 */
	int deleteNotice(int noticeNo) throws SQLException;
}
